Navicat allows you to transfer data from one database/schema to another database/schema with detailed analytical process. In other words, Navicat provides the ability for data in different database/schema to be kept up-to-date so that each repository contains the same information. The target database/schema can be on the same server as the source database/schema or on another server. You are not only authorized to rollback the transferring process, but also insert, delete and update records to the destination. You can also save your settings as a data synchronization profile for setting schedule. Same as Data Transfer, Data Synchronization can be invoked from the command line.
Note:
For Oracle server:
- BLOB, CLOB, NCLOB, LONG and LONG RAW data are skipped during the data synchronization process.
- TIMESTAMP primary key cannot synchronize (insert, update) with Database Link to 9i server.
- RAW primary key cannot synchronize (insert, update, delete) with Database Link to any server, without error.
Note: Only SQL Server 2005 or above supports data synchronization.
Just simply open the data synchronization and use the toolbar below, allowing you to create, save and delete the data synchronization.
Create Data Synchronization
To create a new data synchronization
- Select Tools -> Data Synchronization from the main menu
or just select
New from the toolbar above.
- Edit data synchronization properties on the appropriate tabs.
To create a new data synchronization with modification as one of the existing data synchronization profiles
- Select Tools -> Data Synchronization from the main menu.
- Select the data synchronization for modifying from the Load Profile drop-down list.
- Modify data synchronization properties on the appropriate tabs.
- Click
Save As.
Edit Data Synchronization
To edit the existing data synchronization
- Select Tools -> Data Synchronization from the main menu.
- Select the data synchronization for modifying from the Load Profile drop-down list.
- Modify data synchronization properties on the appropriate tabs.
Preview Data Synchronization
To preview a data synchronization before execution
- Create a new data synchronization/open the existing one.
- Click
Preview.
Run Data Synchronization
To run a data synchronization
- Create a new data synchronization/open the existing one.
- Click
Start.
To run a saved data synchronization profile from the command line
- Create and save the data synchronization profile.
- In terminal, type the command (see Command for details)
Delete Data Synchronization
To delete a data synchronization
- Select Tools -> Data Synchronization from the main menu.
- Select the data synchronization for dropping from the Load Profile drop-down list.
- Click the
Delete from the toolbar.